PostgreSQL 对象管理 查看检查约束
1 查看oa模式下所有的检查约束
SELECT con.conname
FROM pg_catalog.pg_constraint con
INNER JOIN pg_catalog.pg_class rel ON rel.oid = con.conrelid
INNER JOIN pg_catalog.pg_namespace nsp ON nsp.oid = connamespace
WHERE nsp.nspname = 'oa' AND con.contype='c';